package com.wct.mapper;

import com.wct.pojo.User;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @author WEI
 * @date 2018/6/30 14:48
 */
public interface UserMapper {
    User selectUserById(Integer id);

    List<User> selectUserPart1(String username);

    List<User> selectUserPart2(String username);

    List<User> selectUserBySort(String column);

    List<User> selectUserByPage(Integer offset, Integer pageSize);

    List<User> selectUserByPage2(
            @Param("offset") Integer offset,
            @Param("pageSize") Integer pageSize);

    List<User> selectUserByPage3(Map<String, Object> map);

    int insertUser(User user);

    int deleteUserById(Integer id);

    int deleteUserList(List<Integer> ids);

    int updateUser(User user);

    int updateUserSet(User user);

    int updateUserTrim(User user);

    List<User> selectUserActiveIf(User user);
    List<User> selectUserActiveChoose(User user);

    List<User> selectUserActiveWhere(User user);

}
